package com.nannytools.util;

import junit.framework.TestCase;
import com.nannytools.commonObjects.*;
import com.nannytools.util.*;

public class BuildSQLQueryTest extends TestCase {
	public void testBuildSQLQuery() {
		
		try {
			User userTxt = new User();
			userTxt.setUserId(1);
			userTxt.setPayRateType("1");
			userTxt.setPayRateAmount(35000.00);
			userTxt.setUserEmail("user@gmail.com");
			userTxt.setUserFirstName("Al");
			userTxt.setUserLastName("Gore");
			
			BuildSQLQuery insertQuery = new BuildSQLQuery();
			DBConnection conn = new DBConnection ();
			
			conn.executeInsertQuery(insertQuery.insertQueryBuilder(ConnectionStaticVariables.DB_NAME_NANNY, 
					"user", userTxt.convertToArrayAttributes(), userTxt.convertToArray()));

		} catch (Exception e) {
			fail("Not yet implemented");
		}
	}

	public void testInsertQueryBuilder() {
		
		fail("Not yet implemented");
	}

	public void testDeleteQueryBuilder() {
		fail("Not yet implemented");
	}

}
